package com.gxuwz.lhleavesys.dao;

import com.gxuwz.lhleavesys.entity.Teacher;
import java.sql.SQLException;
import java.util.List;

public interface TeacherDao {

    List<Teacher> query(Teacher teacher) throws SQLException;

    /**
     * 根据id查询辅导员信息
     * @param instID
     * @return
     */
    Teacher findByInstID(String instID);

    /**
     *  根据所有查询辅导员信息
     * @return
     * @throw
     */
    List<Teacher> findAllorOne(String instID, String name);

    /**
     * 新增辅导员信息
     * @param teacher
     * @return
     */
    boolean insert(Teacher teacher);

    /**
     * 修改辅导员信息
     * @param teacher
     * @return
     */
    boolean update(Teacher teacher, String id);

    /**
     * 根据id刪除辅导员信息
     * @param instID
     * @return
     */
    boolean delete(String instID);

    Teacher findInstructorByinstName(String name);
}
